package com.example.smart_community.mapper;

import com.example.smart_community.po.Houseinfo;
import org.apache.ibatis.annotations.Mapper;
import org.apache.ibatis.annotations.Result;
import org.apache.ibatis.annotations.Results;
import org.apache.ibatis.annotations.Select;

import java.util.List;

@Mapper
public interface HouseinfoMapper {
    @Select("select * from houseinfo where h_id=#{hId}")
    @Results({
            @Result(property="hId", column="h_id")
    })
    Houseinfo selectById(Integer hId);
    @Select("select * from houseinfo where build=#{build}")
    List<Houseinfo> selectByBuild(Integer build);
}
